UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G1m0uiVB5UAr3KXU0ELPcH0WIhM8A1qPKKzHo48NStM='
WHERE
key_id = 'aaa8c9fc436607dca79e0d797e9002b0de5d4ae39d3108d52b2e0f5a6f07da50'
AND (
token = 'G1m0uiVB5UAr3KXU0ELPcH0WIhM8A1qPKKzHo48NStM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)