UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MgP0HZ4gzPD+RK7/VpPtmB67WXM16S8kY26l5AJLAc8='
WHERE
key_id = '0ac40ba17a28fd7e1b3f173f42303163d9b18d11bfd078055a0737460bb28cb2'
AND (
token = 'MgP0HZ4gzPD+RK7/VpPtmB67WXM16S8kY26l5AJLAc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)