UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'emQGtXICC45zgC5XW89NuLdMdBuD9pj3j381QGCH0KI='
WHERE
key_id = 'a987f8d88a31aad768adff4de6a440d5e00a8857c5e79d73312554ea7b4fedcf'
AND (
token = 'emQGtXICC45zgC5XW89NuLdMdBuD9pj3j381QGCH0KI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)