UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u8tOhrs+rZ+7biuUK5/aDj0EAg8TuX3FtOfPVut38Tc='
WHERE
key_id = 'bae6c47534c01c5c1befcfe57a748b0b5bc1415afacad345ebe04bcb4e5d098b'
AND (
token = 'u8tOhrs+rZ+7biuUK5/aDj0EAg8TuX3FtOfPVut38Tc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)