UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ldY1Rw/iVl8ByLC14YrHtvBXpa4UX/izR4JAaq5YYNE='
WHERE
key_id = 'bcf6a3c9c908dd9a97002430b034c7dd2e07c59758b92bdb1b72a5094f2d0b28'
AND (
token = 'ldY1Rw/iVl8ByLC14YrHtvBXpa4UX/izR4JAaq5YYNE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)