UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f+QVaaBd4mChMUfWhL0TOV9Mbc9en3YOs5zWCu1Px0M='
WHERE
key_id = 'd7bdeee226c147e7a3234b46e4a3901314db988434d6ee820e915e0a01989634'
AND (
token = 'f+QVaaBd4mChMUfWhL0TOV9Mbc9en3YOs5zWCu1Px0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)