UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '31VXPifccD8G1rtOQm5yAaMsc35hFFDT7EMiMSu/lb8='
WHERE
key_id = '5f0d442f8cb4da765ef193d5ccfaf278da1aa6b0fe6ab24a01e2636765704bf2'
AND (
token = '31VXPifccD8G1rtOQm5yAaMsc35hFFDT7EMiMSu/lb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)