UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K1SmU7jpuuGo+9J7Ttvfp4v+XpGSOiY2L7qqICTDJsA='
WHERE
key_id = '15584533bf3e73df206319a5a3a9d30695403e56249074756f697d3c9752a282'
AND (
token = 'K1SmU7jpuuGo+9J7Ttvfp4v+XpGSOiY2L7qqICTDJsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)