UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4wVjaYJkHTPHTwTNxp1mA3Epdwwo5EK1Xn9U2Um3TQo='
WHERE
key_id = 'f0409bfe4dd5808fc9a21a732d1a9197c1a6ba756362d28858b64f557c193efe'
AND (
token = '4wVjaYJkHTPHTwTNxp1mA3Epdwwo5EK1Xn9U2Um3TQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)