UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8EkB0lIfQLjNIUv2ouywRb6v4NSnGVV37gpEWeSaQzA='
WHERE
key_id = 'f03559748e68e83bae2ba150605288a101ab83d1df998223ea8d9b0254876df9'
AND (
token = '8EkB0lIfQLjNIUv2ouywRb6v4NSnGVV37gpEWeSaQzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)