UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bm6QdcpX8bYxW2GjyWbfWJEAwYtYXKx0ptnA5xJQJq4='
WHERE
key_id = '1ed3ab89e0df506792819fc9fe0df67365b51c68f7474f294e9348c01734fedd'
AND (
token = 'bm6QdcpX8bYxW2GjyWbfWJEAwYtYXKx0ptnA5xJQJq4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)