UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K45kHE4WX356mPJRQOguLH0hvF5Fbg3zxkfJ6MAdxEw='
WHERE
key_id = '1f778205cab5340af4f073bb49be81580100aa9a8f2b5c96592e4e3d153afcb3'
AND (
token = 'K45kHE4WX356mPJRQOguLH0hvF5Fbg3zxkfJ6MAdxEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)