UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eHX6p7Xmz+SA2TGX3bJ8q6cXb0i7DXOp/XJkM3UgsE0='
WHERE
key_id = '06c789ba44f086f8c709c5f69a3dde2604dc9dca87485177e0034d86de4a7c20'
AND (
token = 'eHX6p7Xmz+SA2TGX3bJ8q6cXb0i7DXOp/XJkM3UgsE0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)