UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a4iAdPhAagmFCce+djTetJwDxGmJPWpmD2COxnU3i40='
WHERE
key_id = '1ea3481eb39af9952547f4e2f242c33699e68f42e07a804cee69636aa1fbbcda'
AND (
token = 'a4iAdPhAagmFCce+djTetJwDxGmJPWpmD2COxnU3i40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)