UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQ4dAMcVmori+Dicz627be2jSdDIIm9uLhcYPiRB2eM='
WHERE
key_id = 'a5dea6a9ca3e95b1f7cf4f4849461dc90d567f6bf167b717524b5cc0ed683160'
AND (
token = 'zQ4dAMcVmori+Dicz627be2jSdDIIm9uLhcYPiRB2eM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)