UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PF9wz1XJXTakM7rqMM9d7xz5503EcCieHSknrLM1sTk='
WHERE
key_id = 'ae7c1744a96cc5a6721ea8e7331a97ed3a0b220be818e347b2521be2b67ead5d'
AND (
token = 'PF9wz1XJXTakM7rqMM9d7xz5503EcCieHSknrLM1sTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)