UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CYSSiBDymayG+EHbxDNRD1VfsY4r3QxtKd6ydPYhs48='
WHERE
key_id = '8c5675cd53674412b943304084d0f514f77b6ae0977a4b4f4a6892ab169b001b'
AND (
token = 'CYSSiBDymayG+EHbxDNRD1VfsY4r3QxtKd6ydPYhs48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)