UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bTlhiEmSuwEu15L6lFIVUEDlZEFd3hgwqUDV8nzXJz8='
WHERE
key_id = '179e2a87b445a649b11c1e98913de28f3cc47e23c1e0d4b144b93b18c3cd40dc'
AND (
token = 'bTlhiEmSuwEu15L6lFIVUEDlZEFd3hgwqUDV8nzXJz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)