UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hZ4BmubiTrGi5VV90/vi3QccBb+VRK7QiW6dUPB7RKI='
WHERE
key_id = 'c4e63ac5eab8a8ca30059e450615f4df980652abb8738ef01489609a60010806'
AND (
token = 'hZ4BmubiTrGi5VV90/vi3QccBb+VRK7QiW6dUPB7RKI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)