UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1SCWPTKu2Yu9I+BsmZ5qjqePit61D4mB6C1AxrQrHuo='
WHERE
key_id = '50a29aa660d900663ba1263d205aba4dde304497289dfd032b414f5b5d2d062f'
AND (
token = '1SCWPTKu2Yu9I+BsmZ5qjqePit61D4mB6C1AxrQrHuo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)