UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jMds8AQD032eARIEAueoe60M+5xbXMLgNF/L9CEcuyk='
WHERE
key_id = '78953964f0c0504e90a6a27334d1de4e421e3044a570efb6662603f5691c5341'
AND (
token = 'jMds8AQD032eARIEAueoe60M+5xbXMLgNF/L9CEcuyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)