UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U8TZU7exHiHH0fSlI0a+YzYwCn768f3dSa6GKjZF5LE='
WHERE
key_id = '0e665d952f72eb0a83ff468a71d57db7385b0a3457df4e8dae9bcf20b17ce4cc'
AND (
token = 'U8TZU7exHiHH0fSlI0a+YzYwCn768f3dSa6GKjZF5LE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)