UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L+qSr+tp3LwWGeIPhatQBrLmclLtCCWV6eWEBpqXYVU='
WHERE
key_id = 'cda4a0b925edb9b2df6fe05d27dfcaef803a5f199caa3f2df4d9c6419b391ea0'
AND (
token = 'L+qSr+tp3LwWGeIPhatQBrLmclLtCCWV6eWEBpqXYVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)