UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E1pFQukqOfn2lZjUg6MXE60qK8xwbz1aC1sbUHHe9hk='
WHERE
key_id = 'a4d8b4e23a706087ce561023a82b8bd6006a2a2b27af58bf1ff6d4bedbe98feb'
AND (
token = 'E1pFQukqOfn2lZjUg6MXE60qK8xwbz1aC1sbUHHe9hk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)