UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dLK2VIKIOb0d/Sn6wdRvRugaXsSoVbbcFQxEifsOcaE='
WHERE
key_id = '18bc4312d222b2758a32eee095b85ce28845598b7a8a97fe3e4072242c6702d4'
AND (
token = 'dLK2VIKIOb0d/Sn6wdRvRugaXsSoVbbcFQxEifsOcaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)