UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ld7hqsKtVGmTkb8PQy2Pvf8aANd8Bln2FiRUoE/lKmA='
WHERE
key_id = 'e4d2a5a1dcc26e3ccccb59f8afcf0feabc1f0061287e6a92da791882203cd4f2'
AND (
token = 'Ld7hqsKtVGmTkb8PQy2Pvf8aANd8Bln2FiRUoE/lKmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)