UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q2mM/LxBrHkfagX60gKlftAnLagn7Igs2K0xtnRbzYA='
WHERE
key_id = 'b947a04d4a7f93657651fbaaf8c3c44f210779f8944aa59d159ee8115eea6f27'
AND (
token = 'Q2mM/LxBrHkfagX60gKlftAnLagn7Igs2K0xtnRbzYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)