UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pJhU5REKdnx51OezkwZ6pHIaZQSMxTiTOZuJUiUC1zo='
WHERE
key_id = 'd570419d6da67e051b6ff16a4941b5d36b35c35003fecd7341fb171c56e45a58'
AND (
token = 'pJhU5REKdnx51OezkwZ6pHIaZQSMxTiTOZuJUiUC1zo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)