UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N9Wm+nW8sQChqDROcKtsO+c0ntYdBb+TcLLsFicp/Xk='
WHERE
key_id = 'ab265659856851e75e62d85687ce16cb45d9c9856aefe1eb86e4084c40bf2413'
AND (
token = 'N9Wm+nW8sQChqDROcKtsO+c0ntYdBb+TcLLsFicp/Xk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)