UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dpf9I2U1igGvnIqx3ZsSxpS3MA83AAffL4y3YwbwXIk='
WHERE
key_id = '328bb433b8a37ec090f9b59659b742658e80f6f1f1affba75e0fdb0dc976a9cc'
AND (
token = 'Dpf9I2U1igGvnIqx3ZsSxpS3MA83AAffL4y3YwbwXIk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)