UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BPoUa6zEt2ojefS62QOyRRSzXSxB4NGjR1q4Ueh+6Ko='
WHERE
key_id = 'e161607c22adc262afbd0677aa5f9d61a59a49ffef4e0b3a82157be4345786a6'
AND (
token = 'BPoUa6zEt2ojefS62QOyRRSzXSxB4NGjR1q4Ueh+6Ko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)