UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '28i3GTw7ZlDgElDnsT4ixoq3fRktHNnVm4TTwGSJ4is='
WHERE
key_id = '7d3a047ba76a0b33f7b96399c51436c3dfe16579683d1018069bfaca35087ce1'
AND (
token = '28i3GTw7ZlDgElDnsT4ixoq3fRktHNnVm4TTwGSJ4is='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)