UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hXfA4mi68pZWURFLHC+WJqAecRmie2XJ2vDAztRomc8='
WHERE
key_id = 'ec964be29ae421deb751aadb4510fa6529c7ed27bd0d902964176e7ce9f7a04f'
AND (
token = 'hXfA4mi68pZWURFLHC+WJqAecRmie2XJ2vDAztRomc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)