UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zTE42xKLbLLtz5f1VOfXSvuIzo6mZgilygR9TyO/ytc='
WHERE
key_id = '080967890e75ba9bb83d1cd19a0ccc74baf1e04c063f45f68315d284be90cdf8'
AND (
token = 'zTE42xKLbLLtz5f1VOfXSvuIzo6mZgilygR9TyO/ytc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)