UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gMZNvf16+LU0aEk9aOGKmtn8V9EzMKQ2jWn5P9qZBgY='
WHERE
key_id = 'dab937b905602dfc443b6a7d30ae87aafe49f39851cd1584e33f51a8ccade556'
AND (
token = 'gMZNvf16+LU0aEk9aOGKmtn8V9EzMKQ2jWn5P9qZBgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)