UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mygZW44FJAQ/h4GnEmYlp7o9ob8P0nOK6lHZnpz/kGg='
WHERE
key_id = 'e058683ebc07b020082a235dd380fbd95678899e77ad3a127e2fb4072b861773'
AND (
token = 'mygZW44FJAQ/h4GnEmYlp7o9ob8P0nOK6lHZnpz/kGg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)