UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pyy60O+2NNzAStbyd0aq9/U4rTLKKYi0tLAyFoTjc7M='
WHERE
key_id = '78a872e5ec27d1fcd14f3d1df05fffab5e8585e5d3c64dd5527c92bc81ae406c'
AND (
token = 'pyy60O+2NNzAStbyd0aq9/U4rTLKKYi0tLAyFoTjc7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)