UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1KeyW8NyZ6793Be68SLPoRv9CgnI/u9sOJywcIzsUG8='
WHERE
key_id = '59f3947b0b0ef0d4c04a0a4f77ef847e67ef2f64ecbab8d6e1306435ac144f50'
AND (
token = '1KeyW8NyZ6793Be68SLPoRv9CgnI/u9sOJywcIzsUG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)