UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ie38dfS/xqIMMq0bmfCgI9nbcsPUdLcLKONnHwIyxyk='
WHERE
key_id = 'bd88803c25097423c00281e32910c324468c9d1ec2b3554654845be99ea97600'
AND (
token = 'Ie38dfS/xqIMMq0bmfCgI9nbcsPUdLcLKONnHwIyxyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)