UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zYq1Oo/f1cur22rTKo2JDhYIArOtjtrPoSdG4Sqtfoc='
WHERE
key_id = 'b99ee3b6c9f76c1f43563bed21cb84973e97a718f797910299702c7233a9f712'
AND (
token = 'zYq1Oo/f1cur22rTKo2JDhYIArOtjtrPoSdG4Sqtfoc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)